<template>
  <div>
      <el-card shadow="hover" class="mb-[10px]">
          <el-form :model="queryParams" ref="queryRef" :inline="true" v-show="showSearch" label-width="68px">
                          <el-form-item label="名称" prop="name">
                              <el-input
                                      v-model="queryParams.name"
                                      placeholder="请输入名称"
                                      clearable
                                      @keyup.enter="handleQuery"
                              />
                          </el-form-item>
                          <el-form-item label="关键字" prop="code">
                              <el-input
                                      v-model="queryParams.code"
                                      placeholder="请输入关键字"
                                      clearable
                                      @keyup.enter="handleQuery"
                              />
                          </el-form-item>
              <el-form-item>
                  <el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>
                  <el-button icon="Refresh" @click="resetQuery">重置</el-button>
              </el-form-item>
          </el-form>
      </el-card>

      <el-card shadow="hover">
          <template #header>
              <el-row :gutter="10" class="mb8">
                  <el-col :span="1.5">
                      <el-button
                              type="primary"
                              plain
                              icon="Plus"
                              @click="handleAdd"
                              v-hasPermi="['post:/tool/comQuery']"
                      >新增</el-button>
                  </el-col>
                  <el-col :span="1.5">
                      <el-button
                              type="success"
                              plain
                              icon="Edit"
                              :disabled="single"
                              @click="handleUpdate"
                              v-hasPermi="['put:/tool/comQuery']"
                      >修改</el-button>
                  </el-col>
                  <el-col :span="1.5">
                      <el-button
                              type="danger"
                              plain
                              icon="Delete"
                              :disabled="multiple"
                              @click="handleDelete"
                              v-hasPermi="['delete:/tool/comQuery/*']"
                      >删除</el-button>
                  </el-col>
                  <el-col :span="1.5">
                      <el-button
                              type="warning"
                              plain
                              icon="Download"
                              @click="handleExport"
                              v-hasPermi="['post:/tool/comQuery/export']"
                      >导出</el-button>
                  </el-col>
                  <right-toolbar v-model:showSearch="showSearch" @queryTable="getList"></right-toolbar>
              </el-row>
          </template>
          
          <el-table v-loading="loading" :data="comQueryList" @selection-change="handleSelectionChange">
              <el-table-column type="selection" width="55" align="center" />
                      <el-table-column label="编号" align="center" prop="id" v-if="true"/>
                      <el-table-column label="名称" align="center" prop="name" />
                      <el-table-column label="关键字" align="center" prop="code" />
                      <el-table-column label="说明" align="center" prop="remark" />
              <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
                  <template #default="scope">
                      <el-button link type="primary" icon="Edit" @click="handleUpdate(scope.row)" v-hasPermi="['put:/tool/comQuery']">修改</el-button>
                      <el-button link type="primary" icon="Delete" @click="handleDelete(scope.row)" v-hasPermi="['delete:/tool/comQuery/*']">删除</el-button>
                  </template>
              </el-table-column>
          </el-table>

          <pagination
                  v-show="total>0"
                  :total="total"
                  v-model:page="queryParams.pageNum"
                  v-model:limit="queryParams.pageSize"
                  @pagination="getList"
          />
          
      </el-card>

    <!-- 添加或修改通用查询对话框 -->
    <el-dialog :title="title" v-model="open" width="500px" append-to-body>
      <el-form ref="comQueryRef" :model="form" :rules="rules" label-width="80px">
        <el-form-item label="名称" prop="name">
          <el-input v-model="form.name" placeholder="请输入名称" />
        </el-form-item>
          <el-form-item prop="code">
              <template #label>
                  <el-tooltip class="item" effect="dark" :content="'必须以query开头,否则在dict-tap组件中无效,需要自己通过getQueryData获取数据'" placement="top">
                     <span>
                          关键字<svg-icon icon-class="el-QuestionFilled" class="align-middle"/>
                     </span>
                  </el-tooltip>
              
              </template>
              <el-input v-model="form.code" placeholder="请输入关键字" />
          </el-form-item>
          <el-form-item label="sql语句" prop="customSql">
              <el-input v-model="form.customSql" type="textarea" placeholder="请输入内容" />
              <el-button type="primary" size="small" @click="handleTest(form.customSql)">测试</el-button>
          </el-form-item>
        <el-form-item label="说明" prop="remark">
          <el-input v-model="form.remark" placeholder="请输入说明" />
        </el-form-item>
      </el-form>
      <template #footer>
        <div class="dialog-footer">
          <el-button :loading="buttonLoading" type="primary" @click="submitForm">确 定</el-button>
          <el-button @click="cancel">取 消</el-button>
        </div>
      </template>
    </el-dialog>
  </div>
</template>

<script setup name="ComQuery">
import {listComQuery, getComQuery, delComQuery, addComQuery, updateComQuery, testBizData} from "@/api/tool/comQuery";
import SvgIcon from "@/components/SvgIcon/index.vue";

const {msgSuccess, msgError, confirm } = useModal()

const queryRef = ref()
const comQueryRef = ref()

const comQueryList = ref([]);
const open = ref(false);
const buttonLoading = ref(false);
const loading = ref(true);
const showSearch = ref(true);
const ids = ref([]);
const single = ref(true);
const multiple = ref(true);
const total = ref(0);
const title = ref("");

const data = reactive({
  form: {},
  queryParams: {
    pageNum: 1,
    pageSize: 10,
    name: undefined,
    code: undefined,
  },
  rules: {
    id: [
      { required: true, message: "编号不能为空", trigger: "blur" }
    ],
    name: [
      { required: true, message: "名称不能为空", trigger: "blur" }
    ],
    code: [
      { required: true, message: "关键字不能为空", trigger: "blur" }
    ],
    customSql: [
      { required: true, message: "sql语句不能为空", trigger: "blur" }
    ],
  }
});

const { queryParams, form, rules } = toRefs(data);

/** 查询通用查询列表 */
function getList() {
  loading.value = true;
  listComQuery(queryParams.value).then(response => {
    comQueryList.value = response.rows;
    total.value = response.total;
    loading.value = false;
  });
}

// 取消按钮
function cancel() {
  open.value = false;
  reset();
}

// 表单重置
function reset() {
  form.value = {
    id: null,
    name: null,
    code: null,
    remark: null,
    customSql: null,
    config: null
  };
    resetForm(comQueryRef.value);
}

/** 搜索按钮操作 */
function handleQuery() {
  queryParams.value.pageNum = 1;
  getList();
}

/** 重置按钮操作 */
function resetQuery() {
    resetForm(queryRef.value)
  handleQuery();
}

// 多选框选中数据
function handleSelectionChange(selection) {
  ids.value = selection.map(item => item.id);
  single.value = selection.length != 1;
  multiple.value = !selection.length;
}

/** 新增按钮操作 */
function handleAdd() {
  reset();
  open.value = true;
  title.value = "添加通用查询";
}

/** 修改按钮操作 */
function handleUpdate(row) {
  loading.value = true
  reset();
  const _id = row.id || ids.value
  getComQuery(_id).then(response => {
    loading.value = false;
    form.value = response.data;
    open.value = true;
    title.value = "修改通用查询";
  });
}

/** 提交按钮 */
function submitForm() {
        comQueryRef.value.validate(valid => {
    if (valid) {
      buttonLoading.value = true;
      if (form.value.id != null) {
        updateComQuery(form.value).then(response => {
          msgSuccess("修改成功");
          open.value = false;
          getList();
        }).finally(() => {
          buttonLoading.value = false;
        });
      } else {
        addComQuery(form.value).then(() => {
          msgSuccess("新增成功");
          open.value = false;
          getList();
        }).finally(() => {
          buttonLoading.value = false;
        });
      }
    }
  });
}

/** 删除按钮操作 */
function handleDelete(row) {
  const _ids = row.id || ids.value;
  confirm('是否确认删除通用查询编号为"' + _ids + '"的数据项？').then(function() {
    loading.value = true;
    return delComQuery(_ids);
  }).then(() => {
    loading.value = true;
    getList();
    msgSuccess("删除成功");
  }).catch(() => {
  }).finally(() => {
    loading.value = false;
  });
}

/** 导出按钮操作 */
function handleExport() {
  useDownload().downloadByApi('tool/comQuery/export', {
    ...queryParams.value
  }, `comQuery_${new Date().getTime()}.xlsx`)
}

function handleTest(sql) {
    if (!sql) {
        this.msgError("sql不能为空")
    }
    testBizData({ customSql: sql }).then(res => {
        this.msgSuccess("测试成功");
    })
}

getList();
</script>
